package com.ecoolex.ying.space.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class OutsourcingGoodsExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public OutsourcingGoodsExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public OutsourcingGoodsExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public OutsourcingGoodsExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        OutsourcingGoodsExample example = new OutsourcingGoodsExample();
        return example.createCriteria();
    }

    public OutsourcingGoodsExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public OutsourcingGoodsExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public OutsourcingGoodsExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public OutsourcingGoodsExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public OutsourcingGoodsExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andOutsourcingGoodsIdIsNull() {
            addCriterion("outsourcinggoods.OutsourcingGoodsId is null");
            return (Criteria) this;
        }

        public Criteria andOutsourcingGoodsIdIsNotNull() {
            addCriterion("outsourcinggoods.OutsourcingGoodsId is not null");
            return (Criteria) this;
        }

        public Criteria andOutsourcingGoodsIdEqualTo(Integer value) {
            addCriterion("outsourcinggoods.OutsourcingGoodsId =", value, "outsourcingGoodsId");
            return (Criteria) this;
        }

        public Criteria andOutsourcingGoodsIdEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.OutsourcingGoodsId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOutsourcingGoodsIdNotEqualTo(Integer value) {
            addCriterion("outsourcinggoods.OutsourcingGoodsId <>", value, "outsourcingGoodsId");
            return (Criteria) this;
        }

        public Criteria andOutsourcingGoodsIdNotEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.OutsourcingGoodsId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOutsourcingGoodsIdGreaterThan(Integer value) {
            addCriterion("outsourcinggoods.OutsourcingGoodsId >", value, "outsourcingGoodsId");
            return (Criteria) this;
        }

        public Criteria andOutsourcingGoodsIdGreaterThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.OutsourcingGoodsId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOutsourcingGoodsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("outsourcinggoods.OutsourcingGoodsId >=", value, "outsourcingGoodsId");
            return (Criteria) this;
        }

        public Criteria andOutsourcingGoodsIdGreaterThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.OutsourcingGoodsId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOutsourcingGoodsIdLessThan(Integer value) {
            addCriterion("outsourcinggoods.OutsourcingGoodsId <", value, "outsourcingGoodsId");
            return (Criteria) this;
        }

        public Criteria andOutsourcingGoodsIdLessThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.OutsourcingGoodsId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOutsourcingGoodsIdLessThanOrEqualTo(Integer value) {
            addCriterion("outsourcinggoods.OutsourcingGoodsId <=", value, "outsourcingGoodsId");
            return (Criteria) this;
        }

        public Criteria andOutsourcingGoodsIdLessThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.OutsourcingGoodsId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOutsourcingGoodsIdIn(List<Integer> values) {
            addCriterion("outsourcinggoods.OutsourcingGoodsId in", values, "outsourcingGoodsId");
            return (Criteria) this;
        }

        public Criteria andOutsourcingGoodsIdNotIn(List<Integer> values) {
            addCriterion("outsourcinggoods.OutsourcingGoodsId not in", values, "outsourcingGoodsId");
            return (Criteria) this;
        }

        public Criteria andOutsourcingGoodsIdBetween(Integer value1, Integer value2) {
            addCriterion("outsourcinggoods.OutsourcingGoodsId between", value1, value2, "outsourcingGoodsId");
            return (Criteria) this;
        }

        public Criteria andOutsourcingGoodsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("outsourcinggoods.OutsourcingGoodsId not between", value1, value2, "outsourcingGoodsId");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("outsourcinggoods.`Name` is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("outsourcinggoods.`Name` is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("outsourcinggoods.`Name` =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`Name` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("outsourcinggoods.`Name` <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`Name` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("outsourcinggoods.`Name` >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`Name` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.`Name` >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`Name` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("outsourcinggoods.`Name` <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`Name` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.`Name` <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`Name` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("outsourcinggoods.`Name` like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("outsourcinggoods.`Name` not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("outsourcinggoods.`Name` in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("outsourcinggoods.`Name` not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.`Name` between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.`Name` not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andSubNameIsNull() {
            addCriterion("outsourcinggoods.SubName is null");
            return (Criteria) this;
        }

        public Criteria andSubNameIsNotNull() {
            addCriterion("outsourcinggoods.SubName is not null");
            return (Criteria) this;
        }

        public Criteria andSubNameEqualTo(String value) {
            addCriterion("outsourcinggoods.SubName =", value, "subName");
            return (Criteria) this;
        }

        public Criteria andSubNameEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.SubName = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSubNameNotEqualTo(String value) {
            addCriterion("outsourcinggoods.SubName <>", value, "subName");
            return (Criteria) this;
        }

        public Criteria andSubNameNotEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.SubName <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSubNameGreaterThan(String value) {
            addCriterion("outsourcinggoods.SubName >", value, "subName");
            return (Criteria) this;
        }

        public Criteria andSubNameGreaterThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.SubName > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSubNameGreaterThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.SubName >=", value, "subName");
            return (Criteria) this;
        }

        public Criteria andSubNameGreaterThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.SubName >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSubNameLessThan(String value) {
            addCriterion("outsourcinggoods.SubName <", value, "subName");
            return (Criteria) this;
        }

        public Criteria andSubNameLessThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.SubName < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSubNameLessThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.SubName <=", value, "subName");
            return (Criteria) this;
        }

        public Criteria andSubNameLessThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.SubName <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSubNameLike(String value) {
            addCriterion("outsourcinggoods.SubName like", value, "subName");
            return (Criteria) this;
        }

        public Criteria andSubNameNotLike(String value) {
            addCriterion("outsourcinggoods.SubName not like", value, "subName");
            return (Criteria) this;
        }

        public Criteria andSubNameIn(List<String> values) {
            addCriterion("outsourcinggoods.SubName in", values, "subName");
            return (Criteria) this;
        }

        public Criteria andSubNameNotIn(List<String> values) {
            addCriterion("outsourcinggoods.SubName not in", values, "subName");
            return (Criteria) this;
        }

        public Criteria andSubNameBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.SubName between", value1, value2, "subName");
            return (Criteria) this;
        }

        public Criteria andSubNameNotBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.SubName not between", value1, value2, "subName");
            return (Criteria) this;
        }

        public Criteria andCategoryIdIsNull() {
            addCriterion("outsourcinggoods.CategoryId is null");
            return (Criteria) this;
        }

        public Criteria andCategoryIdIsNotNull() {
            addCriterion("outsourcinggoods.CategoryId is not null");
            return (Criteria) this;
        }

        public Criteria andCategoryIdEqualTo(Integer value) {
            addCriterion("outsourcinggoods.CategoryId =", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CategoryId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotEqualTo(Integer value) {
            addCriterion("outsourcinggoods.CategoryId <>", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CategoryId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCategoryIdGreaterThan(Integer value) {
            addCriterion("outsourcinggoods.CategoryId >", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdGreaterThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CategoryId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCategoryIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("outsourcinggoods.CategoryId >=", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdGreaterThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CategoryId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCategoryIdLessThan(Integer value) {
            addCriterion("outsourcinggoods.CategoryId <", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdLessThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CategoryId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCategoryIdLessThanOrEqualTo(Integer value) {
            addCriterion("outsourcinggoods.CategoryId <=", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdLessThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CategoryId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCategoryIdIn(List<Integer> values) {
            addCriterion("outsourcinggoods.CategoryId in", values, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotIn(List<Integer> values) {
            addCriterion("outsourcinggoods.CategoryId not in", values, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdBetween(Integer value1, Integer value2) {
            addCriterion("outsourcinggoods.CategoryId between", value1, value2, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotBetween(Integer value1, Integer value2) {
            addCriterion("outsourcinggoods.CategoryId not between", value1, value2, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCoverImageIsNull() {
            addCriterion("outsourcinggoods.CoverImage is null");
            return (Criteria) this;
        }

        public Criteria andCoverImageIsNotNull() {
            addCriterion("outsourcinggoods.CoverImage is not null");
            return (Criteria) this;
        }

        public Criteria andCoverImageEqualTo(String value) {
            addCriterion("outsourcinggoods.CoverImage =", value, "coverImage");
            return (Criteria) this;
        }

        public Criteria andCoverImageEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CoverImage = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCoverImageNotEqualTo(String value) {
            addCriterion("outsourcinggoods.CoverImage <>", value, "coverImage");
            return (Criteria) this;
        }

        public Criteria andCoverImageNotEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CoverImage <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCoverImageGreaterThan(String value) {
            addCriterion("outsourcinggoods.CoverImage >", value, "coverImage");
            return (Criteria) this;
        }

        public Criteria andCoverImageGreaterThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CoverImage > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCoverImageGreaterThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.CoverImage >=", value, "coverImage");
            return (Criteria) this;
        }

        public Criteria andCoverImageGreaterThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CoverImage >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCoverImageLessThan(String value) {
            addCriterion("outsourcinggoods.CoverImage <", value, "coverImage");
            return (Criteria) this;
        }

        public Criteria andCoverImageLessThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CoverImage < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCoverImageLessThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.CoverImage <=", value, "coverImage");
            return (Criteria) this;
        }

        public Criteria andCoverImageLessThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CoverImage <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCoverImageLike(String value) {
            addCriterion("outsourcinggoods.CoverImage like", value, "coverImage");
            return (Criteria) this;
        }

        public Criteria andCoverImageNotLike(String value) {
            addCriterion("outsourcinggoods.CoverImage not like", value, "coverImage");
            return (Criteria) this;
        }

        public Criteria andCoverImageIn(List<String> values) {
            addCriterion("outsourcinggoods.CoverImage in", values, "coverImage");
            return (Criteria) this;
        }

        public Criteria andCoverImageNotIn(List<String> values) {
            addCriterion("outsourcinggoods.CoverImage not in", values, "coverImage");
            return (Criteria) this;
        }

        public Criteria andCoverImageBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.CoverImage between", value1, value2, "coverImage");
            return (Criteria) this;
        }

        public Criteria andCoverImageNotBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.CoverImage not between", value1, value2, "coverImage");
            return (Criteria) this;
        }

        public Criteria andImagesIsNull() {
            addCriterion("outsourcinggoods.Images is null");
            return (Criteria) this;
        }

        public Criteria andImagesIsNotNull() {
            addCriterion("outsourcinggoods.Images is not null");
            return (Criteria) this;
        }

        public Criteria andImagesEqualTo(String value) {
            addCriterion("outsourcinggoods.Images =", value, "images");
            return (Criteria) this;
        }

        public Criteria andImagesEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.Images = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImagesNotEqualTo(String value) {
            addCriterion("outsourcinggoods.Images <>", value, "images");
            return (Criteria) this;
        }

        public Criteria andImagesNotEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.Images <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImagesGreaterThan(String value) {
            addCriterion("outsourcinggoods.Images >", value, "images");
            return (Criteria) this;
        }

        public Criteria andImagesGreaterThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.Images > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImagesGreaterThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.Images >=", value, "images");
            return (Criteria) this;
        }

        public Criteria andImagesGreaterThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.Images >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImagesLessThan(String value) {
            addCriterion("outsourcinggoods.Images <", value, "images");
            return (Criteria) this;
        }

        public Criteria andImagesLessThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.Images < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImagesLessThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.Images <=", value, "images");
            return (Criteria) this;
        }

        public Criteria andImagesLessThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.Images <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImagesLike(String value) {
            addCriterion("outsourcinggoods.Images like", value, "images");
            return (Criteria) this;
        }

        public Criteria andImagesNotLike(String value) {
            addCriterion("outsourcinggoods.Images not like", value, "images");
            return (Criteria) this;
        }

        public Criteria andImagesIn(List<String> values) {
            addCriterion("outsourcinggoods.Images in", values, "images");
            return (Criteria) this;
        }

        public Criteria andImagesNotIn(List<String> values) {
            addCriterion("outsourcinggoods.Images not in", values, "images");
            return (Criteria) this;
        }

        public Criteria andImagesBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.Images between", value1, value2, "images");
            return (Criteria) this;
        }

        public Criteria andImagesNotBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.Images not between", value1, value2, "images");
            return (Criteria) this;
        }

        public Criteria andCounterPriceIsNull() {
            addCriterion("outsourcinggoods.CounterPrice is null");
            return (Criteria) this;
        }

        public Criteria andCounterPriceIsNotNull() {
            addCriterion("outsourcinggoods.CounterPrice is not null");
            return (Criteria) this;
        }

        public Criteria andCounterPriceEqualTo(BigDecimal value) {
            addCriterion("outsourcinggoods.CounterPrice =", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CounterPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotEqualTo(BigDecimal value) {
            addCriterion("outsourcinggoods.CounterPrice <>", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CounterPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThan(BigDecimal value) {
            addCriterion("outsourcinggoods.CounterPrice >", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CounterPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("outsourcinggoods.CounterPrice >=", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CounterPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThan(BigDecimal value) {
            addCriterion("outsourcinggoods.CounterPrice <", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CounterPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("outsourcinggoods.CounterPrice <=", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CounterPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceIn(List<BigDecimal> values) {
            addCriterion("outsourcinggoods.CounterPrice in", values, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotIn(List<BigDecimal> values) {
            addCriterion("outsourcinggoods.CounterPrice not in", values, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("outsourcinggoods.CounterPrice between", value1, value2, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("outsourcinggoods.CounterPrice not between", value1, value2, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceIsNull() {
            addCriterion("outsourcinggoods.RetailPrice is null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceIsNotNull() {
            addCriterion("outsourcinggoods.RetailPrice is not null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceEqualTo(BigDecimal value) {
            addCriterion("outsourcinggoods.RetailPrice =", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.RetailPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotEqualTo(BigDecimal value) {
            addCriterion("outsourcinggoods.RetailPrice <>", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.RetailPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThan(BigDecimal value) {
            addCriterion("outsourcinggoods.RetailPrice >", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.RetailPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("outsourcinggoods.RetailPrice >=", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.RetailPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThan(BigDecimal value) {
            addCriterion("outsourcinggoods.RetailPrice <", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.RetailPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("outsourcinggoods.RetailPrice <=", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.RetailPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceIn(List<BigDecimal> values) {
            addCriterion("outsourcinggoods.RetailPrice in", values, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotIn(List<BigDecimal> values) {
            addCriterion("outsourcinggoods.RetailPrice not in", values, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("outsourcinggoods.RetailPrice between", value1, value2, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("outsourcinggoods.RetailPrice not between", value1, value2, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andBuyLinkIsNull() {
            addCriterion("outsourcinggoods.BuyLink is null");
            return (Criteria) this;
        }

        public Criteria andBuyLinkIsNotNull() {
            addCriterion("outsourcinggoods.BuyLink is not null");
            return (Criteria) this;
        }

        public Criteria andBuyLinkEqualTo(String value) {
            addCriterion("outsourcinggoods.BuyLink =", value, "buyLink");
            return (Criteria) this;
        }

        public Criteria andBuyLinkEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.BuyLink = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyLinkNotEqualTo(String value) {
            addCriterion("outsourcinggoods.BuyLink <>", value, "buyLink");
            return (Criteria) this;
        }

        public Criteria andBuyLinkNotEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.BuyLink <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyLinkGreaterThan(String value) {
            addCriterion("outsourcinggoods.BuyLink >", value, "buyLink");
            return (Criteria) this;
        }

        public Criteria andBuyLinkGreaterThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.BuyLink > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyLinkGreaterThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.BuyLink >=", value, "buyLink");
            return (Criteria) this;
        }

        public Criteria andBuyLinkGreaterThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.BuyLink >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyLinkLessThan(String value) {
            addCriterion("outsourcinggoods.BuyLink <", value, "buyLink");
            return (Criteria) this;
        }

        public Criteria andBuyLinkLessThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.BuyLink < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyLinkLessThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.BuyLink <=", value, "buyLink");
            return (Criteria) this;
        }

        public Criteria andBuyLinkLessThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.BuyLink <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyLinkLike(String value) {
            addCriterion("outsourcinggoods.BuyLink like", value, "buyLink");
            return (Criteria) this;
        }

        public Criteria andBuyLinkNotLike(String value) {
            addCriterion("outsourcinggoods.BuyLink not like", value, "buyLink");
            return (Criteria) this;
        }

        public Criteria andBuyLinkIn(List<String> values) {
            addCriterion("outsourcinggoods.BuyLink in", values, "buyLink");
            return (Criteria) this;
        }

        public Criteria andBuyLinkNotIn(List<String> values) {
            addCriterion("outsourcinggoods.BuyLink not in", values, "buyLink");
            return (Criteria) this;
        }

        public Criteria andBuyLinkBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.BuyLink between", value1, value2, "buyLink");
            return (Criteria) this;
        }

        public Criteria andBuyLinkNotBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.BuyLink not between", value1, value2, "buyLink");
            return (Criteria) this;
        }

        public Criteria andFreightDescribeIsNull() {
            addCriterion("outsourcinggoods.FreightDescribe is null");
            return (Criteria) this;
        }

        public Criteria andFreightDescribeIsNotNull() {
            addCriterion("outsourcinggoods.FreightDescribe is not null");
            return (Criteria) this;
        }

        public Criteria andFreightDescribeEqualTo(String value) {
            addCriterion("outsourcinggoods.FreightDescribe =", value, "freightDescribe");
            return (Criteria) this;
        }

        public Criteria andFreightDescribeEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.FreightDescribe = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightDescribeNotEqualTo(String value) {
            addCriterion("outsourcinggoods.FreightDescribe <>", value, "freightDescribe");
            return (Criteria) this;
        }

        public Criteria andFreightDescribeNotEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.FreightDescribe <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightDescribeGreaterThan(String value) {
            addCriterion("outsourcinggoods.FreightDescribe >", value, "freightDescribe");
            return (Criteria) this;
        }

        public Criteria andFreightDescribeGreaterThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.FreightDescribe > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightDescribeGreaterThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.FreightDescribe >=", value, "freightDescribe");
            return (Criteria) this;
        }

        public Criteria andFreightDescribeGreaterThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.FreightDescribe >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightDescribeLessThan(String value) {
            addCriterion("outsourcinggoods.FreightDescribe <", value, "freightDescribe");
            return (Criteria) this;
        }

        public Criteria andFreightDescribeLessThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.FreightDescribe < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightDescribeLessThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.FreightDescribe <=", value, "freightDescribe");
            return (Criteria) this;
        }

        public Criteria andFreightDescribeLessThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.FreightDescribe <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightDescribeLike(String value) {
            addCriterion("outsourcinggoods.FreightDescribe like", value, "freightDescribe");
            return (Criteria) this;
        }

        public Criteria andFreightDescribeNotLike(String value) {
            addCriterion("outsourcinggoods.FreightDescribe not like", value, "freightDescribe");
            return (Criteria) this;
        }

        public Criteria andFreightDescribeIn(List<String> values) {
            addCriterion("outsourcinggoods.FreightDescribe in", values, "freightDescribe");
            return (Criteria) this;
        }

        public Criteria andFreightDescribeNotIn(List<String> values) {
            addCriterion("outsourcinggoods.FreightDescribe not in", values, "freightDescribe");
            return (Criteria) this;
        }

        public Criteria andFreightDescribeBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.FreightDescribe between", value1, value2, "freightDescribe");
            return (Criteria) this;
        }

        public Criteria andFreightDescribeNotBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.FreightDescribe not between", value1, value2, "freightDescribe");
            return (Criteria) this;
        }

        public Criteria andServiceDescribeIsNull() {
            addCriterion("outsourcinggoods.ServiceDescribe is null");
            return (Criteria) this;
        }

        public Criteria andServiceDescribeIsNotNull() {
            addCriterion("outsourcinggoods.ServiceDescribe is not null");
            return (Criteria) this;
        }

        public Criteria andServiceDescribeEqualTo(String value) {
            addCriterion("outsourcinggoods.ServiceDescribe =", value, "serviceDescribe");
            return (Criteria) this;
        }

        public Criteria andServiceDescribeEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.ServiceDescribe = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDescribeNotEqualTo(String value) {
            addCriterion("outsourcinggoods.ServiceDescribe <>", value, "serviceDescribe");
            return (Criteria) this;
        }

        public Criteria andServiceDescribeNotEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.ServiceDescribe <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDescribeGreaterThan(String value) {
            addCriterion("outsourcinggoods.ServiceDescribe >", value, "serviceDescribe");
            return (Criteria) this;
        }

        public Criteria andServiceDescribeGreaterThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.ServiceDescribe > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDescribeGreaterThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.ServiceDescribe >=", value, "serviceDescribe");
            return (Criteria) this;
        }

        public Criteria andServiceDescribeGreaterThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.ServiceDescribe >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDescribeLessThan(String value) {
            addCriterion("outsourcinggoods.ServiceDescribe <", value, "serviceDescribe");
            return (Criteria) this;
        }

        public Criteria andServiceDescribeLessThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.ServiceDescribe < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDescribeLessThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.ServiceDescribe <=", value, "serviceDescribe");
            return (Criteria) this;
        }

        public Criteria andServiceDescribeLessThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.ServiceDescribe <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDescribeLike(String value) {
            addCriterion("outsourcinggoods.ServiceDescribe like", value, "serviceDescribe");
            return (Criteria) this;
        }

        public Criteria andServiceDescribeNotLike(String value) {
            addCriterion("outsourcinggoods.ServiceDescribe not like", value, "serviceDescribe");
            return (Criteria) this;
        }

        public Criteria andServiceDescribeIn(List<String> values) {
            addCriterion("outsourcinggoods.ServiceDescribe in", values, "serviceDescribe");
            return (Criteria) this;
        }

        public Criteria andServiceDescribeNotIn(List<String> values) {
            addCriterion("outsourcinggoods.ServiceDescribe not in", values, "serviceDescribe");
            return (Criteria) this;
        }

        public Criteria andServiceDescribeBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.ServiceDescribe between", value1, value2, "serviceDescribe");
            return (Criteria) this;
        }

        public Criteria andServiceDescribeNotBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.ServiceDescribe not between", value1, value2, "serviceDescribe");
            return (Criteria) this;
        }

        public Criteria andOnlineIsNull() {
            addCriterion("outsourcinggoods.`Online` is null");
            return (Criteria) this;
        }

        public Criteria andOnlineIsNotNull() {
            addCriterion("outsourcinggoods.`Online` is not null");
            return (Criteria) this;
        }

        public Criteria andOnlineEqualTo(Boolean value) {
            addCriterion("outsourcinggoods.`Online` =", value, "online");
            return (Criteria) this;
        }

        public Criteria andOnlineEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`Online` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOnlineNotEqualTo(Boolean value) {
            addCriterion("outsourcinggoods.`Online` <>", value, "online");
            return (Criteria) this;
        }

        public Criteria andOnlineNotEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`Online` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOnlineGreaterThan(Boolean value) {
            addCriterion("outsourcinggoods.`Online` >", value, "online");
            return (Criteria) this;
        }

        public Criteria andOnlineGreaterThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`Online` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOnlineGreaterThanOrEqualTo(Boolean value) {
            addCriterion("outsourcinggoods.`Online` >=", value, "online");
            return (Criteria) this;
        }

        public Criteria andOnlineGreaterThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`Online` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOnlineLessThan(Boolean value) {
            addCriterion("outsourcinggoods.`Online` <", value, "online");
            return (Criteria) this;
        }

        public Criteria andOnlineLessThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`Online` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOnlineLessThanOrEqualTo(Boolean value) {
            addCriterion("outsourcinggoods.`Online` <=", value, "online");
            return (Criteria) this;
        }

        public Criteria andOnlineLessThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`Online` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOnlineIn(List<Boolean> values) {
            addCriterion("outsourcinggoods.`Online` in", values, "online");
            return (Criteria) this;
        }

        public Criteria andOnlineNotIn(List<Boolean> values) {
            addCriterion("outsourcinggoods.`Online` not in", values, "online");
            return (Criteria) this;
        }

        public Criteria andOnlineBetween(Boolean value1, Boolean value2) {
            addCriterion("outsourcinggoods.`Online` between", value1, value2, "online");
            return (Criteria) this;
        }

        public Criteria andOnlineNotBetween(Boolean value1, Boolean value2) {
            addCriterion("outsourcinggoods.`Online` not between", value1, value2, "online");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("outsourcinggoods.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("outsourcinggoods.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("outsourcinggoods.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("outsourcinggoods.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("outsourcinggoods.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("outsourcinggoods.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("outsourcinggoods.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("outsourcinggoods.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("outsourcinggoods.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("outsourcinggoods.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("outsourcinggoods.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("outsourcinggoods.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("outsourcinggoods.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("outsourcinggoods.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("outsourcinggoods.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("outsourcinggoods.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("outsourcinggoods.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("outsourcinggoods.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("outsourcinggoods.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("outsourcinggoods.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("outsourcinggoods.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("outsourcinggoods.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("outsourcinggoods.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("outsourcinggoods.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("outsourcinggoods.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("outsourcinggoods.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("outsourcinggoods.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("outsourcinggoods.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("outsourcinggoods.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("outsourcinggoods.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("outsourcinggoods.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("outsourcinggoods.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("outsourcinggoods.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("outsourcinggoods.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("outsourcinggoods.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("outsourcinggoods.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("outsourcinggoods.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("outsourcinggoods.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("outsourcinggoods.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("outsourcinggoods.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("outsourcinggoods.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("outsourcinggoods.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("outsourcinggoods.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("outsourcinggoods.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("outsourcinggoods.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("outsourcinggoods.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("outsourcinggoods.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("outsourcinggoods.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("outsourcinggoods.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("outsourcinggoods.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("outsourcinggoods.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("outsourcinggoods.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("outsourcinggoods.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("outsourcinggoods.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(OutsourcingGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("outsourcinggoods.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("outsourcinggoods.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("outsourcinggoods.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("outsourcinggoods.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("outsourcinggoods.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private OutsourcingGoodsExample example;

        protected Criteria(OutsourcingGoodsExample example) {
            super();
            this.example = example;
        }

        public OutsourcingGoodsExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(OutsourcingGoods.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(OutsourcingGoods.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.ying.space.entity.OutsourcingGoodsExample example);
    }
}